This chapter contains the following topics:
Printing Checking Account Reports
The Reports selection grants access to several reports for Passport Business Solutions Check Reconciliation.
From the Reports menu, you may print the following C/R reports:
| • | The Reconciliation Report |
| • | The Checkbook Report |
| • | The Checkbook List |
| • | The Account Activity Report |
You may also print your Checking Account List and your Distribution To G/L report from the Reports menu.
This report is designed to help you with a reconciliation that is in progress. You can print previous reconciliations, as well as cleared and uncleared entries.
The Reconciliation Report normally has two parts:
| • | The list of checkbook entries. |
| • | If a reconciliation is currently in progress, the reconciliation summary shows the same information as is shown on the reconciliation summary screen of Reconcile statements. |
See a Reconciliation Report example in the Sample Reports appendix.
Select
Reconciliation from the Reports menu.
Graphical Mode
The following screen displays:
Skip to the Checking account field.
Character Mode
Options
A screen displays for you to enter the checking account for which you want to print the report. You can also use the option:
|
<F1> |
For the next checking account |
|
Example |
Press <F1>, then press <Enter> twice |
Select Enter and the following screen displays:
For character mode skip to the Statement date field.
Enter the information as follows:
In graphical mode only, enter the checking account for which you want to print the report. You can also use the option:
|
<F1> |
For the next checking account |
|
<SF1> |
For the previous checking account |
|
<F8> |
For accessing the lookup for selecting the account. In graphical mode you may also click on the lookup button |
|
Example |
Press <F1>, then press <Enter> |
Enter the date of the bank statement. You can press <Enter> to default to the date of the current statement if a reconciliation is in progress; otherwise, <Enter> defaults to the date of the last statement that has been reconciled. You may use the option:
|
<F4> |
Graphical mode: For accessing the calendar date selector or click on the calendar button Character mode: Use <F7> to access a date selector |
|
Format |
MMDDYY |
|
Example |
Type 41519 |
Check the box (or answer Y in character mode) if you want to show entries that have already been cleared on the reconciliation date; otherwise, leave it unchecked (answer N).
Stop payment types will print on the report even though they are cleared.
|
Example |
Graphical mode: Check the box using the space bar Character mode: Type Y |
Check the box (or answer Y in character mode) if you want to show uncleared entries; otherwise; leave it unchecked (answer N).
|
Example |
Graphical mode: Check the box using the space bar Character mode: Type Y |
If you selected to show uncleared entries, enter the cut-off date. All uncleared entries having dates on or before this date will be shown on the report. You can press <Enter> to default to the reconciliation date.You may use the option:
|
<F4> |
Graphical mode: For accessing the calendar date selector or click on the calendar button Character mode: Use <F7> to access a date selector |
|
Format |
MMDDYY |
|
Example |
Press <Enter> |
Enter OK to select and printer and print the report or cancel to not print and return to the menu.
This report shows checkbook entries in order by date, along with a running balance.
See a Checkbook Report example in the Sample Reports appendix.
Select
Checkbook from the Reports menu.
The following screen displays in graphical mode:
Options
Enter the checking account for which you want to print the report. You can also use the option:
|
<F1> |
For the next checking account |
|
<SF1> |
For the previous checking account |
|
<F8> |
For accessing the lookup where you can select the checking account |
|
Example |
Press <F1>, then in graphical mode press <Enter>. In character mode press <Enter> twice |
After you enter the checking account, the following screen displays in character mode:
Enter the following information:
Ending date
Enter the range of dates to show on the report. You may use the options:
|
<F2> |
For Earliest on Starting date and Latest on Ending date |
|
<F4> |
Graphical mode: For accessing the calendar date selector or click on the calendar button. Character mode: Use <F7> to access a date selector |
|
Format |
MMDDYY in each field |
|
Example |
Press <F2> for each field for a range from Earliest to Latest |
The Starting balance is the balance of all entries before the starting date.
Select OK to print the report or cancel to return to the menu without printing the report.
Select
Checkbook list from the Reports menu.
Graphical Mode
This screen displays:
Character Mode
The following screen displays:
See a Checkbook List example in the Sample Reports appendix.
Enter the information as follows:
Options
Enter the number of the checking account you want to print the report for, or use one of the options:
|
<F1> |
For the next checking account |
|
<SF1> |
For the previous checking account |
|
<F5> |
To print the report for All checking accounts |
|
<F8> |
To access the lookup |
|
Example |
Press <F5> |
Enter the range of dates to show on the report. Follow the screen instructions. You have this option:
|
<F4> |
In graphical mode, to access the date selector for both fields. In character mode use <F7> |
|
Format |
MMDDYY |
|
Example |
Press <F2> for each field for a range from earliest to latest |
If you change the status of an entry to Void or Stop-payment, the date that action was taken will appear in the Clear-date column of the report.
Select OK to print the report or Cancel to return to the menu without printing.
This report shows checkbook activity in several different ways. You can look at just about any cross-section of entries you have in your checking account.
For example, you could print a list of checks written to a specific payee and a list of which of those checks have cleared. Or you could print a report showing which entries originated from A/P, Payroll, or A/R, or which entries you entered directly in C/R.
See an Account Activity Report example in the Sample Reports appendix.
Select
Account activity from the Reports menu.
The following screen displays:
Graphical Mode
Enter the checking account for which to print the activity report or use the option:
|
<F1> |
For the next checking account |
|
<SF1> |
For the previous checking account |
|
<F8> |
For finding the account via the lookup. You may also click on the lookup button |
Character Mode
Options
Enter the checking account for which to print the activity report or use the option:
|
<F1> |
For the next checking account |
|
<SF1> |
For the previous checking account |
|
Example |
Press <F1>, then press <Enter> twice. |
The following screen displays:
Options
Enter one of the following (or press <Enter> for date order):
|
Character mode |
Graphical Mode |
|
1 |
Date |
|
2 |
Document number |
|
3 |
Payee number |
|
4 |
Payee name |
|
Format |
Graphical mode: Drop down list Character mode: Numeric, enter either 1, 2, 3 or 4 |
|
Example |
Press <Enter> |
Ending
Enter the range of values to show on the report. The field names (and values to enter) depend on what order has been entered above, as follows:
|
Date |
Starting/Ending date |
|
Document number |
Starting/Ending document # |
|
Payee number |
Starting/Ending payee # |
|
Payee name |
Starting/Ending payee name |
Options
Press <Enter> at each type of entry you want to show on the report and answer N at those types you don’t want to show, or use the option:
|
<F5> |
To show "All" types of entries |
|
Example |
Press <F5> |
Options
Press Enter> at each status you want to show and answer N at those types you don’t want to show, or use the option:
|
<F5> |
To show "All" statuses |
|
Example |
Press <F5> |
Options
Press <Enter> at each source you want to show and uncheck the box (answer N) at those sources you don’t want to show. Using character mode Not applicable displays for each module you are not using. You can also use this option if any modules are interfaced:
|
<F5> |
To show "All" sources |
The entries shown for each source are:
|
Direct Entry |
Shows entries entered directly into Check Reconciliation using Checkbook entries. Direct entry must be set to Y (default) if you are not transferring from A/P, Payroll or A/R (as defined in the Control information). Direct entries may also come from external applications through a direct SQL interface or Data import. |
|
Accounts Payable |
Shows checks transferred from A/P |
|
Payroll |
Shows checks transferred from Payroll |
|
Accounts Receivable |
Shows deposits transferred from A/R |
|
Example |
Defaults to Y for Direct Entry, since Check Reconciliation is being used stand-alone |
Options
This question can only be entered if you selected to print in date order or document number order, and you have selected to show checks. If neither A/P nor Payroll is being used your entry is not relevant; otherwise, select one of the following:
| Character Mode | Graphical Mode | What it does |
|
N |
No |
does not show checks for a single payee |
|
V |
A/P Vendor |
shows checks from A/P for a single vendor |
|
E |
PR Employee |
shows checks from Payroll for a single employee |
|
D |
Direct Entry |
shows checks entered directly into the Check Reconciliation module for a single payee |
|
Note |
Direct Entry refers to a single payee only. You must have selected to print in date order or document order, as well as selected to show checks. |
If you are not using A/P, you cannot select a single vendor. If you are not using Payroll, you cannot select a single employee.
If you select A/P Vendor (or enter V), enter the vendor number (you can enter a vendor that is not on file in A/P vendors), or use one of the options:
|
<F1> |
For the next vendor |
|
<SF1> |
For the previous vendor |
|
<Enter> |
Leave the vendor number blank to look up the vendor by name. The screen prompts you to select a vendor by name. |
If you select PR employee (or enter E), you can select a single employee in the same way.
If you select Direct entry or A/P vendor (enter D or V in character mode), enter the payee number or use the option to look up the payee by name. Checks having a payee number matching the number you entered, or having a payee name matching the portion you entered, will be shown.
|
Format |
Graphical mode: Drop down list Character mode: One character |
|
Example |
Press <Enter> for No |
Select OK to print the report or cancel to return to the menu without printing the report.